﻿CREATE PROCEDURE [dbo].[Leagues_SelectByBowlerId]
   @bowler_id uniqueidentifier
AS
  SELECT [dbo].[Leagues].[league_id],
         [dbo].[Leagues].[league_name]
    FROM [dbo].[Leagues]
         INNER JOIN [dbo].[League_Members]
                    ON [dbo].[Leagues].[league_id] = [dbo].[League_Members].[league_id]
   WHERE [dbo].[League_Members].[bowler_id] = @bowler_id


